EMT Practice Test

1. Question Content...

---

Question1: What are some of the typical roles in an SAP HANA Cloud implementation? Note: There are 2 correct answers to this question.

Question2: You have imported calculation views from SAP HANA on-premise to SAP HANA Cloud. Why should you switch calculated column expression language from column engine to SQL?

Question3: Which project structure object corresponds to a unique HDI container?

Question4: You create a table function to remove historic records, sum the current total weekly working hours for each employee, and update the personnel table with the results. The deployment of the table function fails. Which of the following could be a valid reason?

Question5: A new release of SAP HANA Cloud, SAP HANA database is available as of today. If you do not perform the upgrade manually, how much time do you have before your database will be automatically upgraded to the next release?

Question6: What options do you have to handle orphan nodes in your hierarchy? Note: There are 2 correct answers to this question.

Question7: You created a table and inserted data in it using SQL statements inside the SAP HANA Deployment Infrastructure (HDI) container of your project. You add this table as a data source to a calculation view and try to deploy it. What do you observe in the SAP HANA database container?

Question8: Which of the following approaches might improve the performance of joins in a CUBE calculation view?
Note: There are 2 correct answers to this question.

Question9: What are some of the restrictions that apply when defining parallelization blocks in calculation views?
Note: There are 2 correct answers to this question.

Question10: What is a restricted measure?

Question11: A calculation view consumes the data sources shown in the graphic. You want to identify which companies sold products in January AND February. What is the optimal way to do this?

Question12: Why do you use the Hidden Columns checkbox in the semantics node of your calculation view? Note:
There are 2 correct answers to this question.

Question13: Two calculation views, A and B, are defined as shown in the diagram. Three analytic privileges have been granted to you. When you preview calculation view A, what data do you see?

Question14: In a database module, what is the purpose of the .hdiconfig file?

Question15: At which levels of a project structure can you execute a deploy operation? Note: There are 2 correct answers to this question.

Question16: In SAP HANA Cloud, which tasks are handled by the cloud provider? Note: There are 3 correct answers to this question.

Question17: In a calculation view, why would you implement an SQL expression? Note: There are 3 correct answers to this question.

Question18: In a calculation view, why would you choose the DEPRECATED setting? Note: There are 2 correct answers to this question.

Question19: What are the consequences of NOT executing a delta merge? Note: There are 2 correct answers to this question.

Question20: You have generated a calculation view properties file. What does it contain?

Question21: Why would you create SQL in calculation views?

Question22: In your calculation view, you want to consume a custom data source defined using SQLScript. In which type of object do you write your code?

Question23: You combine two customer master data tables with a union node in a calculation view. Both master data tables include the same customer name. How do you ensure that each customer name appears only once in the results?

Question24: Which of the following techniques can you use to improve the performance of calculation views? Note:
There are 2 correct answers to this question.

Question25: You have defined a pruning configuration table in a calculation view. What are you attempting to prune from the query execution?

Question26: What must you consider when defining analytic privileges using the DYNAMIC option? Note: There are 3 correct answers to this question.

Question27: Using the table in the diagram, you need to create a CUBE calculation view. What is the simplest approach to create the output shown in the screenshot?

Question28: You want to map an input parameter of calculation view A to an input parameter of calculation view B using the parameter mapping feature in the calculation view editor. However, the input parameters of calculation view B are not proposed as source parameters. What might be the reason for this?